home *** CD-ROM | disk | FTP | other *** search
/ Developer Source 17 / Developer Source Volume 17 (I-MODE Publications, Inc.)(2000).iso / oracl / 991 / bobrf101.gif < prev    next >
Graphics Interchange Format  |  2000-01-03  |  36.8 KB  |  482x319  |  4-bit (16 colors)
   ocr: FIGURE I: Affer loading data into the data-warehouse detail tables, you can create: a summary as a materialized view. Oraclesi can thon rewrite a summory query that targets the detailtables to access the materialized view, for faster response time. By refreshing a materialized view, you can keep the summary, data consistent with the underlying data En the detail tablos. You can also use Oracle8i's summary advisor to analyze the benefit of existing and potential materialized views. incremental Extraction of Date Warehouse OLIP Database New Delail Data DotoilTablee Application Auto Query Query R ...